object ItemsForm: TItemsForm
  Left = 0
  Top = 0
  ActiveControl = DBGridEh
  Caption = 'Items'
  ClientHeight = 569
  ClientWidth = 804
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  KeyPreview = True
  OldCreateOrder = False
  OnCloseQuery = FormCloseQuery
  OnHide = FormHide
  OnKeyDown = FormKeyDown
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object DBGridEh: TDBGridEh
    Left = 0
    Top = 213
    Width = 804
    Height = 135
    TabStop = False
    Align = alClient
    AllowedOperations = [alopUpdateEh, alopAppendEh]
    AutoFitColWidths = True
    Color = 14745599
    DataGrouping.GroupLevels = <>
    DataSource = DataSource
    DrawMemoText = True
    Flat = True
    FooterColor = clWindow
    FooterFont.Charset = DEFAULT_CHARSET
    FooterFont.Color = clWindowText
    FooterFont.Height = -11
    FooterFont.Name = 'Tahoma'
    FooterFont.Style = []
    IndicatorOptions = [gioShowRowIndicatorEh]
    Options = [dgTitles, dgIndicator, dgColLines, dgRowLines, dgAlwaysShowSelection, dgConfirmDelete]
    OptionsEh = [dghFixed3D, dghResizeWholeRightPart, dghHighlightFocus, dghClearSelection, dghAutoSortMarking, dghMultiSortMarking, dghTraceColSizing, dghIncSearch, dghPreferIncSearch, dghRowHighlight, dghDialogFind, dghColumnResize, dghHotTrack, dghExtendVertLines]
    ParentShowHint = False
    ShowHint = True
    STFilter.InstantApply = False
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
    VertScrollBar.VisibleMode = sbAlwaysShowEh
    OnDblClick = DBGridEhDblClick
    OnKeyDown = DBGridEhKeyDown
    OnSortMarkingChanged = DBGridEhSortMarkingChanged
    Columns = <
      item
        EditButtons = <>
        EndEllipsis = True
        FieldName = 'NAME'
        Footers = <>
        Title.Alignment = taCenter
        Title.Caption = 'Item'#39's Name'
        Title.SortIndex = 1
        Title.SortMarker = smDownEh
        Title.TitleButton = True
        ToolTips = True
        Width = 350
        OnAdvDrawDataCell = DBGridEhColumns0AdvDrawDataCell
      end
      item
        Alignment = taCenter
        EditButtons = <>
        EndEllipsis = True
        FieldName = 'BASIC_UNIT_NAME'
        Footers = <>
        Title.Alignment = taCenter
        Title.Caption = 'Basic Unit'
        Title.TitleButton = True
        ToolTips = True
        Width = 77
      end
      item
        Alignment = taCenter
        Color = 14745584
        EditButtons = <>
        EndEllipsis = True
        FieldName = 'CATEGORY_NAME'
        Footers = <>
        Title.Alignment = taCenter
        Title.Caption = 'Category'
        Title.TitleButton = True
        ToolTips = True
      end
      item
        Color = 16773344
        EditButtons = <>
        EndEllipsis = True
        FieldName = 'PHARM_GROUPS_LIST'
        Footers = <>
        Title.Alignment = taCenter
        Title.Caption = 'Pharmaceutical Groups'
        Title.TitleButton = True
        ToolTips = True
        Width = 379
      end>
    object RowDetailData: TRowDetailPanelControlEh
    end
  end
  object ToolBar: TToolBar
    Left = 0
    Top = 0
    Width = 804
    Height = 22
    AutoSize = True
    ButtonWidth = 65
    Caption = 'ToolBar'
    DoubleBuffered = False
    Images = ImageList
    List = True
    ParentDoubleBuffered = False
    ShowCaptions = True
    TabOrder = 1
    Wrapable = False
    object AddToolButton: TToolButton
      Left = 0
      Top = 0
      Hint = 'Add'
      Caption = 'Add      '
      ImageIndex = 0
      ParentShowHint = False
      ShowHint = True
      Style = tbsCheck
      OnClick = AddToolButtonClick
    end
    object ToolButton3: TToolButton
      Left = 65
      Top = 0
      Width = 8
      Caption = 'ToolButton3'
      ImageIndex = 3
      Style = tbsSeparator
    end
    object DeleteToolButton: TToolButton
      Left = 73
      Top = 0
      Hint = 'Delete'
      Caption = 'Delete  '
      ImageIndex = 1
      ParentShowHint = False
      ShowHint = True
      Style = tbsTextButton
      OnClick = DeleteToolButtonClick
    end
    object ToolButton1: TToolButton
      Left = 138
      Top = 0
      Width = 8
      Caption = 'ToolButton1'
      ImageIndex = 3
      Style = tbsSeparator
    end
    object EditToolButton: TToolButton
      Left = 146
      Top = 0
      Caption = 'Edit      '
      ImageIndex = 3
      Style = tbsCheck
      OnClick = EditToolButtonClick
    end
    object ToolButton2: TToolButton
      Left = 211
      Top = 0
      Width = 8
      Caption = 'ToolButton2'
      ImageIndex = 3
      Style = tbsSeparator
    end
    object RefreshToolButton: TToolButton
      Left = 219
      Top = 0
      Hint = 'Refresh'
      Caption = 'Refresh'
      ImageIndex = 2
      ParentShowHint = False
      ShowHint = True
      Style = tbsTextButton
      OnClick = RefreshToolButtonClick
    end
    object ToolButton4: TToolButton
      Left = 284
      Top = 0
      Width = 8
      Caption = 'ToolButton4'
      ImageIndex = 3
      Style = tbsSeparator
    end
    object FiltersToolButton: TToolButton
      Left = 292
      Top = 0
      Caption = 'Filters'
      ImageIndex = 6
      Style = tbsCheck
      OnClick = FiltersToolButtonClick
    end
    object ToolButton6: TToolButton
      Left = 357
      Top = 0
      Width = 8
      Caption = 'ToolButton6'
      ImageIndex = 4
      Style = tbsSeparator
    end
  end
  object EditorPanel: TPanel
    Left = 0
    Top = 348
    Width = 804
    Height = 221
    Align = alBottom
    BevelOuter = bvNone
    DoubleBuffered = False
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Tahoma'
    Font.Style = []
    ParentDoubleBuffered = False
    ParentFont = False
    ShowCaption = False
    TabOrder = 2
    Visible = False
    DesignSize = (
      804
      221)
    object MedDetailsGroupBox: TGroupBox
      Left = 297
      Top = 28
      Width = 500
      Height = 156
      Anchors = [akLeft, akTop, akRight]
      Caption = ' '
      Enabled = False
      TabOrder = 1
      DesignSize = (
        500
        156)
      object GenericNameLabel: TLabel
        Left = 9
        Top = 22
        Width = 69
        Height = 13
        Caption = 'Generic name:'
        Enabled = False
      end
      object AuthLevelLabel: TLabel
        Left = 9
        Top = 130
        Width = 73
        Height = 13
        Caption = 'Authoriz. level:'
        Enabled = False
      end
      object MedicinalFormLabel: TLabel
        Left = 9
        Top = 49
        Width = 72
        Height = 13
        Caption = 'Medicinal form:'
        Enabled = False
      end
      object MedDetailsGroupBoxLabel: TLabel
        Left = 9
        Top = 0
        Width = 81
        Height = 13
        Caption = ' Medicine details '
        Enabled = False
        Transparent = False
      end
      object PharmGroupsLabel: TLabel
        Left = 290
        Top = 0
        Width = 135
        Height = 13
        Caption = '        Pharmaceutical groups '
        Enabled = False
        Transparent = False
      end
      object PharmGroupsSpeedButton: TSpeedButton
        Left = 293
        Top = -1
        Width = 17
        Height = 17
        Hint = 'Pharmaceutical Groups editor'
        Enabled = False
        Glyph.Data = {
          3E050000424D3E050000000000003604000028000000160000000B0000000100
          080000000000080100000000000000000000000100000000000000000000FFFF
          FF004A4A4A00ECECEC008000800080800000C0C0C000808080000000FF0000FF
          000000FFFF00FF000000FF00FF00FFFF0000FBFBFB00F2F2F200090909001212
          12001F1F1F002C2C2C003939390045454500525252005F5F5F006C6C6C007878
          780085858500929292009F9F9F00ABABAB00B8B8B800C5C5C500D2D2D200DEDE
          DE00EBEBEB00F8F8F800F0FBFF00A4A0A000C0DCC000F0CAA60000003E000000
          5D0000007C0000009B000000BA000000D9000000F0002424FF004848FF006C6C
          FF009090FF00B4B4FF0000143E00001E5D0000287C0000329B00003CBA000046
          D9000055F000246DFF004885FF006C9DFF0090B5FF00B4CDFF00002A3E00003F
          5D0000547C0000699B00007EBA000093D90000AAF00024B6FF0048C2FF006CCE
          FF0090DAFF00B4E6FF00003E3E00005D5D00007C7C00009B9B0000BABA0000D9
          D90000F0F00024FFFF0048FFFF006CFFFF0090FFFF00B4FFFF00003E2A00005D
          3F00007C5400009B690000BA7E0000D9930000F0AA0024FFB60048FFC2006CFF
          CE0090FFDA00B4FFE600003E1400005D1E00007C2800009B320000BA3C0000D9
          460000F0550024FF6D0048FF85006CFF9D0090FFB500B4FFCD00003E0000005D
          0000007C0000009B000000BA000000D9000000F0000024FF240048FF48006CFF
          6C0090FF9000B4FFB400143E00001E5D0000287C0000329B00003CBA000046D9
          000055F000006DFF240085FF48009DFF6C00B5FF9000CDFFB4002A3E00003F5D
          0000547C0000699B00007EBA000093D90000AAF00000B6FF2400C2FF4800CEFF
          6C00DAFF9000E6FFB4003E3E00005D5D00007C7C00009B9B0000BABA0000D9D9
          0000F0F00000FFFF2400FFFF4800FFFF6C00FFFF9000FFFFB4003E2A00005D3F
          00007C5400009B690000BA7E0000D9930000F0AA0000FFB62400FFC24800FFCE
          6C00FFDA9000FFE6B4003E1400005D1E00007C2800009B320000BA3C0000D946
          0000F0550000FF6D2400FF854800FF9D6C00FFB59000FFCDB4003E0000005D00
          00007C0000009B000000BA000000D9000000F0000000FF242400FF484800FF6C
          6C00FF909000FFB4B4003E0014005D001E007C0028009B003200BA003C00D900
          4600F0005500FF246D00FF488500FF6C9D00FF90B500FFB4CD003E002A005D00
          3F007C0054009B006900BA007E00D9009300F000AA00FF24B600FF48C200FF6C
          CE00FF90DA00FFB4E6003E003E005D005D007C007C009B009B00BA00BA00D900
          D900F000F000FF24FF00FF48FF00FF6CFF00FF90FF00FFB4FF002A003E003F00
          5D0054007C0069009B007E00BA009300D900AA00F000B624FF00C248FF00CE6C
          FF00DA90FF00E6B4FF00FAFAFA00F1F1F100EFEFEF0069696900DDDDDD00DADA
          DA00D6D6D600F4F4F400D1D1D1006D6D6D00CFCFCF009999990068FEFEFEFEFE
          FEFEFEFE6868FBFBFBFBFBFBFBFBFB680000FCFCFCFCFCFCFCFCFCFCFCFBFBFB
          FBFBFBFBFBFBFBFB00002020202020202020202020FBFBFBFBFBFBFBFBFBFBFB
          0000FAFAFAFAFAFAFAFAFAFAFAFBFBFBFBFBFBFBFBFBFBFB0000F9F9F9F9F9F9
          F9F9F9F9F9FB0101FBFB0101FBFB01010000F7F7F8F8F7F7F8F8F7F7F8FFFF01
          FBFFFF01FBFFFF0100000202030302020303020203FDFDFBFBFDFDFBFBFDFDFB
          0000F6F6F6F6F6F6F6F6F6F6F6FBFBFBFBFBFBFBFBFBFBFB0000F5F5F5F5F5F5
          F5F5F5F5F5FBFBFBFBFBFBFBFBFBFBFB00000F0F0F0F0F0F0F0F0F0F0FFBFBFB
          FBFBFBFBFBFBFBFB0000680F0F0F0F0F0F0F0F0F6868FBFBFBFBFBFBFBFBFB68
          0000}
        NumGlyphs = 2
        ParentShowHint = False
        ShowHint = True
        OnClick = PharmGroupsSpeedButtonClick
      end
      object DosageLabel: TLabel
        Left = 9
        Top = 76
        Width = 40
        Height = 13
        Caption = 'Dosage:'
        Enabled = False
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Tahoma'
        Font.Style = []
        ParentFont = False
      end
      object TempRegimeLabel: TLabel
        Left = 9
        Top = 103
        Width = 69
        Height = 13
        Caption = 'Temp. regime:'
        Enabled = False
      end
      object PharmGroupsSetDBGridEh: TDBGridEh
        Left = 293
        Top = 19
        Width = 199
        Height = 129
        TabStop = False
        AllowedOperations = []
        Anchors = [akLeft, akTop, akRight]
        AutoFitColWidths = True
        Color = 14745599
        DataGrouping.GroupLevels = <>
        DataSource = PharmGroupsSetDataSource
        Enabled = False
        Flat = True
        FooterColor = clBtnFace
        FooterFont.Charset = DEFAULT_CHARSET
        FooterFont.Color = clWindowText
        FooterFont.Height = -11
        FooterFont.Name = 'Tahoma'
        FooterFont.Style = []
        ImeMode = imDisable
        IndicatorOptions = []
        Options = [dgColLines, dgRowLines, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
        OptionsEh = [dghFixed3D, dghHighlightFocus, dghClearSelection, dghDialogFind, dghColumnResize, dghExtendVertLines]
        ParentShowHint = False
        ShowHint = True
        SumList.Active = True
        TabOrder = 1
        TitleFont.Charset = DEFAULT_CHARSET
        TitleFont.Color = clWindowText
        TitleFont.Height = -11
        TitleFont.Name = 'Tahoma'
        TitleFont.Style = []
        OnCellClick = PharmGroupsSetDBGridEhCellClick
        OnDblClick = PharmGroupsSetDBGridEhDblClick
        OnEnter = PharmGroupsSetDBGridEhEnter
        OnExit = PharmGroupsSetDBGridEhExit
        OnKeyDown = PharmGroupsSetDBGridEhKeyDown
        OnKeyPress = EhKeyPress
        OnSumListAfterRecalcAll = PharmGroupsSetDBGridEhSumListAfterRecalcAll
        Columns = <
          item
            EditButtons = <>
            EndEllipsis = True
            FieldName = 'NAME'
            Footers = <>
            Title.Alignment = taCenter
            Title.Caption = 'Pharmaceutical Groups'
            ToolTips = True
            Width = 220
            OnGetCellParams = PharmGroupsSetDBGridEhColumnsGetCellParams
          end
          item
            AutoFitColWidth = False
            Checkboxes = True
            EditButtons = <>
            FieldName = 'IS_SELECTED'
            Footer.FieldName = 'IS_SELECTED'
            Footer.ValueType = fvtSum
            Footers = <>
            Visible = False
            Width = 32
            OnGetCellParams = PharmGroupsSetDBGridEhColumnsGetCellParams
          end>
        object RowDetailData: TRowDetailPanelControlEh
        end
      end
      object TracerDBCheckBoxEh: TDBCheckBoxEh
        Left = 235
        Top = 129
        Width = 52
        Height = 17
        Caption = 'Trace'
        Enabled = False
        TabOrder = 6
        OnKeyPress = EhKeyPress
        ValueChecked = '1'
        ValueUnchecked = '0'
      end
      object GenericNameDBLookupComboboxEh: TDBLookupComboboxEh
        Left = 87
        Top = 19
        Width = 200
        Height = 21
        Color = 14745599
        DataField = ''
        DropDownBox.Columns = <
          item
            Color = 16769232
            FieldName = 'NAME'
          end>
        DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
        DropDownBox.SortLocal = True
        DropDownBox.AutoDrop = True
        DropDownBox.Sizable = True
        Enabled = False
        EditButton.Visible = False
        EditButtons = <
          item
            OnClick = DBLookupComboboxEhDropDownButtonClick
          end
          item
            Hint = 'Generic Names editor'
            ShortCut = 0
            Style = ebsEllipsisEh
            OnClick = GenericNameDBLookupComboboxEhEditButtonClick
          end>
        KeyField = 'ID'
        ListField = 'NAME'
        ListSource = GenericNamesDataSource
        ParentShowHint = False
        Style = csDropDownEh
        TabOrder = 0
        Tooltips = True
        Visible = True
        OnChange = GenericNameDBLookupComboboxEhValueChanged
        OnKeyDown = DBLookupComboboxEhKeyDown
        OnKeyPress = EhKeyPress
        OnKeyValueChanged = GenericNameDBLookupComboboxEhValueChanged
      end
      object AuthLevelDBComboBoxEh: TDBComboBoxEh
        Left = 87
        Top = 127
        Width = 66
        Height = 21
        Color = 14745599
        DropDownBox.AutoDrop = True
        Enabled = False
        EditButton.Visible = False
        EditButtons = <
          item
            OnClick = DBComboBoxEhDropDownButtonClick
          end>
        Items.Strings = (
          'A'
          'B'
          'C')
        KeyItems.Strings = (
          'A'
          'B'
          'C')
        ParentShowHint = False
        TabOrder = 5
        Tooltips = True
        Visible = True
        OnKeyDown = DBLookupComboboxEhKeyDown
        OnKeyPress = EhKeyPress
      end
      object MedFormDBLookupComboboxEh: TDBLookupComboboxEh
        Left = 87
        Top = 46
        Width = 200
        Height = 21
        Color = 14745599
        DataField = ''
        DropDownBox.Columns = <
          item
            Color = 16769232
            FieldName = 'NAME'
          end>
        DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
        DropDownBox.AutoDrop = True
        DropDownBox.Sizable = True
        Enabled = False
        EditButton.Visible = False
        EditButtons = <
          item
            OnClick = DBLookupComboboxEhDropDownButtonClick
          end
          item
            Hint = 'Medicinal Forms editor'
            ShortCut = 0
            Style = ebsEllipsisEh
            OnClick = MedFormDBLookupComboboxEhEditButtonClick
          end>
        KeyField = 'ID'
        ListField = 'NAME'
        ListSource = MedFormsDataSource
        ParentShowHint = False
        Style = csDropDownEh
        TabOrder = 2
        Tooltips = True
        Visible = True
        OnChange = MedFormDBLookupComboboxEhValueChanged
        OnKeyDown = DBLookupComboboxEhKeyDown
        OnKeyPress = EhKeyPress
        OnKeyValueChanged = MedFormDBLookupComboboxEhValueChanged
      end
      object DosageDBEditEh: TDBEditEh
        Left = 87
        Top = 73
        Width = 200
        Height = 21
        Color = 14745599
        EditButtons = <>
        Enabled = False
        ParentShowHint = False
        TabOrder = 3
        Tooltips = True
        Visible = True
        OnKeyPress = EhKeyPress
      end
      object TempRegimeDBLookupComboboxEh: TDBLookupComboboxEh
        Left = 87
        Top = 100
        Width = 200
        Height = 21
        Color = 14745599
        DataField = ''
        DropDownBox.Columns = <
          item
            Color = 16769232
            FieldName = 'NAME'
          end>
        DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
        DropDownBox.AutoDrop = True
        DropDownBox.Sizable = True
        Enabled = False
        EditButton.Visible = False
        EditButtons = <
          item
            OnClick = DBLookupComboboxEhDropDownButtonClick
          end
          item
            Hint = 'Medicinal Forms editor'
            ShortCut = 0
            Style = ebsEllipsisEh
          end>
        KeyField = 'ID'
        ListField = 'NAME'
        ListSource = TempRegimesDataSource
        ParentShowHint = False
        TabOrder = 4
        Tooltips = True
        Visible = True
        OnChange = TempRegimeDBLookupComboboxEhChange
        OnEnter = TempRegimeDBLookupComboboxEhEnter
        OnKeyDown = DBLookupComboboxEhKeyDown
        OnKeyPress = EhKeyPress
        OnKeyValueChanged = MedFormDBLookupComboboxEhValueChanged
      end
    end
    object SaveButton: TButton
      Left = 665
      Top = 189
      Width = 63
      Height = 26
      Anchors = [akRight, akBottom]
      Caption = 'Save'
      ImageIndex = 4
      ImageMargins.Left = 5
      Images = ImageList
      TabOrder = 2
      OnClick = SaveButtonClick
    end
    object ItemGroupBox: TGroupBox
      Left = 6
      Top = 28
      Width = 285
      Height = 156
      Caption = ' Item '
      TabOrder = 0
      object ItemNameLabel: TLabel
        Left = 9
        Top = 22
        Width = 62
        Height = 13
        Caption = 'Item'#39's name:'
      end
      object CategoryLabel: TLabel
        Left = 9
        Top = 49
        Width = 49
        Height = 13
        Caption = 'Category:'
        Color = clBtnFace
        Enabled = False
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Tahoma'
        Font.Style = []
        ParentColor = False
        ParentFont = False
      end
      object BasicUnitLabel: TLabel
        Left = 9
        Top = 103
        Width = 49
        Height = 13
        Caption = 'Basic unit:'
        Enabled = False
      end
      object DescriptionLabel: TLabel
        Left = 9
        Top = 130
        Width = 57
        Height = 13
        Caption = 'Description:'
        Enabled = False
      end
      object ItemNameDBLookupComboboxEh: TDBLookupComboboxEh
        Left = 77
        Top = 19
        Width = 200
        Height = 21
        Color = 14745599
        DataField = ''
        DropDownBox.Columns = <
          item
            Color = 16769232
            FieldName = 'NAME'
          end>
        DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
        DropDownBox.AutoDrop = True
        DropDownBox.Sizable = True
        EditButton.Visible = False
        EditButtons = <
          item
            OnClick = DBLookupComboboxEhDropDownButtonClick
          end
          item
            Hint = 'Item Names editor'
            ShortCut = 0
            Style = ebsEllipsisEh
            OnClick = ItemNameDBLookupComboboxEhEditButtonClick
          end>
        KeyField = 'ID'
        ListField = 'NAME'
        ListSource = ItemNamesDataSource
        ParentShowHint = False
        Style = csDropDownEh
        TabOrder = 0
        Tooltips = True
        Visible = True
        OnChange = ItemNameDBLookupComboboxEhValueChanged
        OnKeyDown = DBLookupComboboxEhKeyDown
        OnKeyPress = EhKeyPress
        OnKeyValueChanged = ItemNameDBLookupComboboxEhValueChanged
      end
      object CategoryDBLookupComboboxEh: TDBLookupComboboxEh
        Left = 77
        Top = 46
        Width = 200
        Height = 21
        Color = 14745599
        DataField = ''
        DropDownBox.Columns = <
          item
            Color = 16769232
            FieldName = 'NAME'
          end>
        DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
        DropDownBox.AutoDrop = True
        DropDownBox.Sizable = True
        Enabled = False
        EditButton.Visible = False
        EditButtons = <
          item
            OnClick = DBLookupComboboxEhDropDownButtonClick
          end
          item
            Hint = 'Item Categories editor'
            ShortCut = 0
            Style = ebsEllipsisEh
            OnClick = CategoriesDBLookupComboboxEhEditButtonClick
          end>
        KeyField = 'ID'
        ListField = 'NAME'
        ListSource = CategoriesDataSource
        ParentShowHint = False
        Style = csDropDownEh
        TabOrder = 1
        Tooltips = True
        Visible = True
        OnChange = CategoriesDBLookupComboboxEhValueChanged
        OnKeyDown = DBLookupComboboxEhKeyDown
        OnKeyPress = EhKeyPress
        OnKeyValueChanged = CategoriesDBLookupComboboxEhValueChanged
      end
      object BasicUnitDBLookupComboboxEh: TDBLookupComboboxEh
        Left = 77
        Top = 100
        Width = 116
        Height = 21
        Color = 14745599
        DataField = ''
        DropDownBox.Columns = <
          item
            Color = 16769232
            FieldName = 'NAME'
          end>
        DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
        DropDownBox.AutoDrop = True
        DropDownBox.Sizable = True
        Enabled = False
        EditButton.Visible = False
        EditButtons = <
          item
            OnClick = DBLookupComboboxEhDropDownButtonClick
          end
          item
            Hint = 'Basic Units editor'
            ShortCut = 0
            Style = ebsEllipsisEh
            OnClick = BasicUnitDBLookupComboboxEhEditButtonClick
          end>
        KeyField = 'ID'
        ListField = 'NAME'
        ListSource = BasicUnitsDataSource
        ParentShowHint = False
        Style = csDropDownEh
        TabOrder = 3
        Tooltips = True
        Visible = True
        OnChange = BasicUnitDBLookupComboboxEhValueChanged
        OnKeyDown = DBLookupComboboxEhKeyDown
        OnKeyPress = EhKeyPress
        OnKeyValueChanged = BasicUnitDBLookupComboboxEhValueChanged
      end
      object IsHazardousDBCheckBoxEh: TDBCheckBoxEh
        Left = 199
        Top = 102
        Width = 78
        Height = 17
        Caption = 'Hazardous'
        Enabled = False
        TabOrder = 4
        OnKeyPress = EhKeyPress
        ValueChecked = '1'
        ValueUnchecked = '0'
      end
      object DescriptionDBEditEh: TDBEditEh
        Left = 77
        Top = 127
        Width = 200
        Height = 21
        Color = 14745599
        EditButtons = <>
        Enabled = False
        ParentShowHint = False
        TabOrder = 5
        Tooltips = True
        Visible = True
        OnKeyPress = EhKeyPress
      end
      object GenNameAsItemNameDBCheckBoxEh: TDBCheckBoxEh
        Left = 77
        Top = 75
        Width = 199
        Height = 17
        Caption = 'Generic name as item'#39's name'
        Enabled = False
        TabOrder = 2
        OnClick = GenNameAsItemNameDBCheckBoxEhClick
        OnKeyPress = EhKeyPress
        ValueChecked = '1'
        ValueUnchecked = '0'
      end
    end
    object EditorCaptionPanel: TPanel
      Left = 0
      Top = 0
      Width = 804
      Height = 22
      Align = alTop
      Alignment = taLeftJustify
      BevelEdges = [beTop]
      BevelKind = bkTile
      BevelOuter = bvNone
      Caption = '   Editor'
      Color = clInactiveCaption
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clGrayText
      Font.Height = -16
      Font.Name = 'Tahoma'
      Font.Style = [fsBold]
      ParentBackground = False
      ParentFont = False
      ShowCaption = False
      TabOrder = 3
      DesignSize = (
        804
        20)
      object EditorCaptionLabel2: TLabel
        Left = 0
        Top = 0
        Width = 120
        Height = 20
        Align = alLeft
        Caption = '  Editing item: '
        Layout = tlCenter
        ExplicitHeight = 19
      end
      object EditorCaptionLabel3: TLabel
        AlignWithMargins = True
        Left = 123
        Top = 3
        Width = 171
        Height = 17
        Margins.Bottom = 0
        Align = alLeft
        Caption = 'item name and description'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clGrayText
        Font.Height = -13
        Font.Name = 'Tahoma'
        Font.Style = [fsBold]
        ParentFont = False
        Layout = tlCenter
        ExplicitHeight = 16
      end
      object CloseEditorSpeedButton: TSpeedButton
        Left = 785
        Top = 1
        Width = 16
        Height = 17
        Anchors = [akTop, akRight]
        Flat = True
        Glyph.Data = {
          06050000424D060500000000000036040000280000000D0000000D0000000100
          080000000000D000000000000000000000000001000000000000000000000101
          0100020202000303030004040400050505000606060007070700080808000909
          09000A0A0A000B0B0B000C0C0C000D0D0D000E0E0E000F0F0F00101010001111
          1100121212001313130014141400151515001616160017171700181818001919
          19001A1A1A001B1B1B001C1C1C001D1D1D001E1E1E001F1F1F00202020002121
          2100222222002323230024242400252525002626260027272700282828002929
          29002A2A2A002B2B2B002C2C2C002D2D2D002E2E2E002F2F2F00303030003131
          3100323232003333330034343400353535003636360037373700383838003939
          39003A3A3A003B3B3B003C3C3C003D3D3D003E3E3E003F3F3F00404040004141
          4100424242004343430044444400454545004646460047474700484848004949
          49004A4A4A004B4B4B004C4C4C004D4D4D004E4E4E004F4F4F00505050005151
          5100525252005353530054545400555555005656560057575700585858005959
          59005A5A5A005B5B5B005C5C5C005D5D5D005E5E5E005F5F5F00606060006161
          6100626262006363630064646400656565006666660067676700686868006969
          69006A6A6A006B6B6B006C6C6C006D6D6D006E6E6E006F6F6F00707070007171
          7100727272007373730074747400757575007676760077777700787878007979
          79007A7A7A007B7B7B007C7C7C007D7D7D007E7E7E007F7F7F00808080008181
          8100828282008383830084848400858585008686860087878700888888008989
          89008A8A8A008B8B8B008C8C8C008D8D8D008E8E8E008F8F8F00909090009191
          9100929292009393930094949400959595009696960097979700989898009999
          99009A9A9A009B9B9B009C9C9C009D9D9D009E9E9E009F9F9F00A0A0A000A1A1
          A100A2A2A200A3A3A300A4A4A400A5A5A500A6A6A600A7A7A700A8A8A800A9A9
          A900AAAAAA00ABABAB00ACACAC00ADADAD00AEAEAE00AFAFAF00B0B0B000B1B1
          B100B2B2B200B3B3B300B4B4B400B5B5B500B6B6B600B7B7B700B8B8B800B9B9
          B900BABABA00BBBBBB00BCBCBC00BDBDBD00BEBEBE00BFBFBF00C0C0C000C1C1
          C100C2C2C200C3C3C300C4C4C400C5C5C500C6C6C600C7C7C700C8C8C800C9C9
          C900CACACA00CBCBCB00CCCCCC00CDCDCD00CECECE00CFCFCF00D0D0D000D1D1
          D100D2D2D200D3D3D300D4D4D400D5D5D500D6D6D600D7D7D700D8D8D800D9D9
          D900DADADA00DBDBDB00DCDCDC00DDDDDD00DEDEDE00DFDFDF00E0E0E000E1E1
          E100E2E2E200E3E3E300E4E4E400E5E5E500E6E6E600E7E7E700E8E8E800E9E9
          E900EAEAEA00EBEBEB00ECECEC00EDEDED00EEEEEE00EFEFEF00F0F0F000F1F1
          F100F2F2F200F3F3F300F4F4F400F5F5F500F6F6F600F7F7F700F8F8F800F9F9
          F900FAFAFA00FBFBFB00FCFCFC00FDFDFD00FEFEFE00FFFFFF00C0C0C0C0C0C0
          C0C0C0C0C0C0C0000000C0C0C0C0C0C0C0C0C0C0C0C0C0000000C0C0736CC0C0
          C0C06B7BC0C0C0000000C0816B6B6DC0C06B6B6B92C0C0000000C0C0736B6B6B
          6B6B6B7BC0C0C0000000C0C0C0756B6B6B6B7CC0C0C0C0000000C0C0C0C06B6B
          6B6BC0C0C0C0C0000000C0C0C06B6B6B6B6B6DC0C0C0C0000000C0C06B6B6B7A
          746B6B6CC0C0C0000000C08F6B6B7CC0C0766B6BA0C0C0000000C0C08C7CC0C0
          C0C0749AC0C0C0000000C0C0C0C0C0C0C0C0C0C0C0C0C0000000C0C0C0C0C0C0
          C0C0C0C0C0C0C0000000}
        OnClick = CloseEditorSpeedButtonClick
        ExplicitLeft = 848
      end
    end
    object CancelButton: TButton
      Left = 734
      Top = 189
      Width = 63
      Height = 26
      Anchors = [akRight, akBottom]
      Caption = 'Cancel'
      ImageIndex = 5
      ImageMargins.Left = 5
      Images = ImageList
      TabOrder = 4
      OnClick = CancelButtonClick
    end
  end
  object FiltersPanel: TPanel
    Left = 0
    Top = 22
    Width = 804
    Height = 191
    Align = alTop
    BevelOuter = bvNone
    ShowCaption = False
    TabOrder = 3
    Visible = False
    OnResize = FiltersPanelResize
    object FiltersCaptionPanel: TPanel
      Left = 0
      Top = 0
      Width = 804
      Height = 22
      Align = alTop
      Alignment = taLeftJustify
      BevelEdges = [beTop]
      BevelKind = bkTile
      BevelOuter = bvNone
      Caption = '   Editor'
      Color = clInactiveCaption
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clGrayText
      Font.Height = -16
      Font.Name = 'Tahoma'
      Font.Style = [fsBold]
      ParentBackground = False
      ParentFont = False
      ShowCaption = False
      TabOrder = 2
      DesignSize = (
        804
        20)
      object Label3: TLabel
        Left = 0
        Top = 0
        Width = 72
        Height = 20
        Align = alLeft
        Caption = '  Filters: '
        Layout = tlCenter
        ExplicitHeight = 19
      end
      object CloseFiltersSpeedButton: TSpeedButton
        Left = 785
        Top = 1
        Width = 16
        Height = 17
        Anchors = [akTop, akRight]
        Flat = True
        Glyph.Data = {
          06050000424D060500000000000036040000280000000D0000000D0000000100
          080000000000D000000000000000000000000001000000000000000000000101
          0100020202000303030004040400050505000606060007070700080808000909
          09000A0A0A000B0B0B000C0C0C000D0D0D000E0E0E000F0F0F00101010001111
          1100121212001313130014141400151515001616160017171700181818001919
          19001A1A1A001B1B1B001C1C1C001D1D1D001E1E1E001F1F1F00202020002121
          2100222222002323230024242400252525002626260027272700282828002929
          29002A2A2A002B2B2B002C2C2C002D2D2D002E2E2E002F2F2F00303030003131
          3100323232003333330034343400353535003636360037373700383838003939
          39003A3A3A003B3B3B003C3C3C003D3D3D003E3E3E003F3F3F00404040004141
          4100424242004343430044444400454545004646460047474700484848004949
          49004A4A4A004B4B4B004C4C4C004D4D4D004E4E4E004F4F4F00505050005151
          5100525252005353530054545400555555005656560057575700585858005959
          59005A5A5A005B5B5B005C5C5C005D5D5D005E5E5E005F5F5F00606060006161
          6100626262006363630064646400656565006666660067676700686868006969
          69006A6A6A006B6B6B006C6C6C006D6D6D006E6E6E006F6F6F00707070007171
          7100727272007373730074747400757575007676760077777700787878007979
          79007A7A7A007B7B7B007C7C7C007D7D7D007E7E7E007F7F7F00808080008181
          8100828282008383830084848400858585008686860087878700888888008989
          89008A8A8A008B8B8B008C8C8C008D8D8D008E8E8E008F8F8F00909090009191
          9100929292009393930094949400959595009696960097979700989898009999
          99009A9A9A009B9B9B009C9C9C009D9D9D009E9E9E009F9F9F00A0A0A000A1A1
          A100A2A2A200A3A3A300A4A4A400A5A5A500A6A6A600A7A7A700A8A8A800A9A9
          A900AAAAAA00ABABAB00ACACAC00ADADAD00AEAEAE00AFAFAF00B0B0B000B1B1
          B100B2B2B200B3B3B300B4B4B400B5B5B500B6B6B600B7B7B700B8B8B800B9B9
          B900BABABA00BBBBBB00BCBCBC00BDBDBD00BEBEBE00BFBFBF00C0C0C000C1C1
          C100C2C2C200C3C3C300C4C4C400C5C5C500C6C6C600C7C7C700C8C8C800C9C9
          C900CACACA00CBCBCB00CCCCCC00CDCDCD00CECECE00CFCFCF00D0D0D000D1D1
          D100D2D2D200D3D3D300D4D4D400D5D5D500D6D6D600D7D7D700D8D8D800D9D9
          D900DADADA00DBDBDB00DCDCDC00DDDDDD00DEDEDE00DFDFDF00E0E0E000E1E1
          E100E2E2E200E3E3E300E4E4E400E5E5E500E6E6E600E7E7E700E8E8E800E9E9
          E900EAEAEA00EBEBEB00ECECEC00EDEDED00EEEEEE00EFEFEF00F0F0F000F1F1
          F100F2F2F200F3F3F300F4F4F400F5F5F500F6F6F600F7F7F700F8F8F800F9F9
          F900FAFAFA00FBFBFB00FCFCFC00FDFDFD00FEFEFE00FFFFFF00C0C0C0C0C0C0
          C0C0C0C0C0C0C0000000C0C0C0C0C0C0C0C0C0C0C0C0C0000000C0C0736CC0C0
          C0C06B7BC0C0C0000000C0816B6B6DC0C06B6B6B92C0C0000000C0C0736B6B6B
          6B6B6B7BC0C0C0000000C0C0C0756B6B6B6B7CC0C0C0C0000000C0C0C0C06B6B
          6B6BC0C0C0C0C0000000C0C0C06B6B6B6B6B6DC0C0C0C0000000C0C06B6B6B7A
          746B6B6CC0C0C0000000C08F6B6B7CC0C0766B6BA0C0C0000000C0C08C7CC0C0
          C0C0749AC0C0C0000000C0C0C0C0C0C0C0C0C0C0C0C0C0000000C0C0C0C0C0C0
          C0C0C0C0C0C0C0000000}
        OnClick = CloseFiltersSpeedButtonClick
        ExplicitLeft = 848
      end
    end
    object LeftFiltersPanel: TPanel
      Left = 0
      Top = 22
      Width = 387
      Height = 169
      Align = alLeft
      BevelOuter = bvNone
      Caption = 'LeftFiltersPanel'
      ShowCaption = False
      TabOrder = 0
      DesignSize = (
        387
        169)
      object EditMarkImage: TImage
        Left = 6
        Top = 113
        Width = 27
        Height = 9
        AutoSize = True
        Picture.Data = {
          055449636F6E0000010001001B09000001000800480500001600000028000000
          1B00000012000000010008000000000020010000000000000000000000010000
          0000000000000000FFFFFF000080000000808000800000008000800080800000
          C0C0C000C0DCC000F0CAA6003300000000003300330033003333000016161600
          1C1C1C002222220029292900555555004D4D4D004242420039393900807CFF00
          5050FF009300D600FFECCC00C6D6EF00D6E7E70090A9AD0000FF330000006600
          000099000000CC00003300000033330000336600003399000033CC000033FF00
          006600000066330000666600006699000066CC000066FF000099000000993300
          00996600009999000099CC000099FF0000CC000000CC330000CC660000CC9900
          00CCCC0000CCFF0000FF660000FF990000FFCC0033FF0000FF00330033006600
          330099003300CC003300FF00FF3300003333330033336600333399003333CC00
          3333FF00336600003366330033666600336699003366CC003366FF0033990000
          3399330033996600339999003399CC003399FF0033CC000033CC330033CC6600
          33CC990033CCCC0033CCFF0033FF330033FF660033FF990033FFCC0033FFFF00
          660000006600330066006600660099006600CC006600FF006633000066333300
          66336600663399006633CC006633FF0066660000666633006666660066669900
          6666CC00669900006699330066996600669999006699CC006699FF0066CC0000
          66CC330066CC990066CCCC0066CCFF0066FF000066FF330066FF990066FFCC00
          CC00FF00FF00CC009999000099339900990099009900CC009900000099333300
          990066009933CC009900FF00996600009966330099336600996699009966CC00
          9933FF009999330099996600999999009999CC009999FF0099CC000099CC3300
          66CC660099CC990099CCCC0099CCFF0099FF000099FF330099CC660099FF9900
          99FFCC0099FFFF00CC00000099003300CC006600CC009900CC00CC0099330000
          CC333300CC336600CC339900CC33CC00CC33FF00CC660000CC66330099666600
          CC669900CC66CC009966FF00CC990000CC993300CC996600CC999900CC99CC00
          CC99FF00CCCC0000CCCC3300CCCC6600CCCC9900CCCCCC00CCCCFF00CCFF0000
          CCFF330099FF6600CCFF9900CCFFCC00CCFFFF00CC003300FF006600FF009900
          CC330000FF333300FF336600FF339900FF33CC00FF33FF00FF660000FF663300
          CC666600FF669900FF66CC00CC66FF00FF990000FF993300FF996600FF999900
          FF99CC00FF99FF00FFCC0000FFCC3300FFCC6600FFCC9900FFCCCC00FFCCFF00
          FFFF3300CCFF6600FFFF9900FFFFCC006666FF0066FF660066FFFF00FF666600
          FF66FF00FFFF66002100A5005F5F5F00777777008686860096969600CBCBCB00
          B2B2B200D7D7D700DDDDDD00E3E3E300EAEAEA00F1F1F100F8F8F800F0FBFF00
          A4A0A000808080000000FF0000FF000000FFFF00FF000000FF00FF00FFFF0000
          FFFFFF0000000000000000000000000000000000000000000000000000000000
          002020202020202020202020202020202020202020202020202000000020FBFB
          FB20FBFB2020FB2020FB2020FB20FB20FB2020FB202000000020FB202020FB20
          FB20FB2020FB2020FB20FBFBFB20FB20FB2000000020FBFB2020FB20FB20FB20
          20FB2020FB20FBFBFB20FB20FB2000000020FB202020FB20FB20FB2020FB2020
          FB20FB20FB20FB20202000000020FBFBFB20FBFB2020FB20FBFBFB20FB20FB20
          FB2020FBFB200000002020202020202020202020202020202020202020202020
          2020000000000000000000000000000000000000000000000000000000000000
          8000002000000000000000000000000000000000000000000000000000000000
          80000020}
        Visible = False
      end
      object ItemsFilterGroupBox: TGroupBox
        Left = 6
        Top = 6
        Width = 378
        Height = 101
        Anchors = [akLeft, akTop, akRight]
        Caption = ' Item'
        TabOrder = 0
        DesignSize = (
          378
          101)
        object ItemNameFilterLabel: TLabel
          Left = 9
          Top = 22
          Width = 62
          Height = 13
          Caption = 'Item'#39's name:'
        end
        object CategoryFilterLabel: TLabel
          Left = 9
          Top = 49
          Width = 49
          Height = 13
          Caption = 'Category:'
          Color = clBtnFace
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clWindowText
          Font.Height = -11
          Font.Name = 'Tahoma'
          Font.Style = []
          ParentColor = False
          ParentFont = False
        end
        object ItemNameFilterDBLookupComboboxEh: TDBLookupComboboxEh
          Left = 82
          Top = 19
          Width = 288
          Height = 21
          Anchors = [akLeft, akTop, akRight]
          Color = 14745599
          DataField = ''
          DropDownBox.Columns = <
            item
              Color = 16769232
              FieldName = 'NAME'
            end>
          DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
          DropDownBox.AutoDrop = True
          DropDownBox.Sizable = True
          EmptyDataInfo.Text = '- Any -'
          EmptyDataInfo.Font.Charset = DEFAULT_CHARSET
          EmptyDataInfo.Font.Color = clSilver
          EmptyDataInfo.Font.Height = -11
          EmptyDataInfo.Font.Name = 'Tahoma'
          EmptyDataInfo.Font.Style = [fsItalic]
          EmptyDataInfo.ParentFont = False
          EditButton.Visible = False
          EditButtons = <
            item
              OnClick = DBLookupComboboxEhDropDownButtonClick
            end>
          KeyField = 'ID'
          ListField = 'NAME'
          ListSource = ItemNameFilterDataSource
          ParentShowHint = False
          Style = csDropDownEh
          TabOrder = 0
          Tooltips = True
          Visible = True
          OnKeyDown = DBLookupComboboxEhKeyDown
          OnKeyPress = EhKeyPress
        end
        object CategoryFilterDBLookupComboboxEh: TDBLookupComboboxEh
          Left = 82
          Top = 46
          Width = 288
          Height = 21
          Anchors = [akLeft, akTop, akRight]
          Color = 14745599
          DataField = ''
          DropDownBox.Columns = <
            item
              Color = 16769232
              FieldName = 'NAME'
            end>
          DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
          DropDownBox.AutoDrop = True
          DropDownBox.Sizable = True
          EditButton.Visible = False
          EditButtons = <
            item
              OnClick = DBLookupComboboxEhDropDownButtonClick
            end>
          KeyField = 'ID'
          ListField = 'NAME'
          ListSource = CategoriesFilterDataSource
          ParentShowHint = False
          TabOrder = 1
          Tooltips = True
          Visible = True
          OnKeyDown = DBLookupComboboxEhKeyDown
          OnKeyPress = EhKeyPress
          OnKeyValueChanged = CategoryFilterDBLookupComboboxEhKeyValueChanged
        end
        object HazardousOnlyDBCheckBoxEh: TDBCheckBoxEh
          Left = 82
          Top = 75
          Width = 123
          Height = 17
          Caption = 'Hazardous only'
          TabOrder = 2
          OnKeyPress = EhKeyPress
          ValueChecked = '1'
          ValueUnchecked = '0'
        end
      end
    end
    object RightFiltersPanel: TPanel
      Left = 387
      Top = 22
      Width = 417
      Height = 169
      Align = alClient
      BevelOuter = bvNone
      Caption = 'LeftFiltersPanel'
      ParentBackground = False
      ShowCaption = False
      TabOrder = 1
      DesignSize = (
        417
        169)
      object MedicineFilterGroupBox: TGroupBox
        Left = 3
        Top = 6
        Width = 407
        Height = 128
        Anchors = [akLeft, akTop, akRight]
        Caption = ' '
        TabOrder = 0
        DesignSize = (
          407
          128)
        object GenericNameFilterLabel: TLabel
          Left = 9
          Top = 22
          Width = 69
          Height = 13
          Caption = 'Generic name:'
          Enabled = False
        end
        object AuthLevelFilterLabel: TLabel
          Left = 9
          Top = 103
          Width = 73
          Height = 13
          Caption = 'Authoriz. level:'
          Enabled = False
        end
        object MedicineFilterGroupBoxLabel: TLabel
          Left = 9
          Top = 0
          Width = 47
          Height = 13
          Caption = ' Medicine '
          Enabled = False
          Transparent = False
        end
        object TempRegimeFilterLabel: TLabel
          Left = 9
          Top = 76
          Width = 69
          Height = 13
          Caption = 'Temp. regime:'
          Enabled = False
        end
        object PharmGroupFilterLabel: TLabel
          Left = 9
          Top = 49
          Width = 69
          Height = 13
          Caption = 'Pharm. group:'
          Enabled = False
        end
        object GenericNameFilterDBLookupComboboxEh: TDBLookupComboboxEh
          Left = 88
          Top = 19
          Width = 311
          Height = 21
          Anchors = [akLeft, akTop, akRight]
          Color = 14745599
          DataField = ''
          DropDownBox.Columns = <
            item
              Color = 16769232
              FieldName = 'NAME'
            end>
          DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
          DropDownBox.AutoDrop = True
          DropDownBox.Sizable = True
          Enabled = False
          EditButton.Visible = False
          EditButtons = <
            item
              OnClick = DBLookupComboboxEhDropDownButtonClick
            end>
          KeyField = 'ID'
          ListField = 'NAME'
          ListSource = GenericNamesFilterDataSource
          ParentShowHint = False
          TabOrder = 0
          Tooltips = True
          Visible = True
          OnKeyDown = DBLookupComboboxEhKeyDown
          OnKeyPress = EhKeyPress
        end
        object AuthLevelFilterDBComboBoxEh: TDBComboBoxEh
          Left = 88
          Top = 100
          Width = 66
          Height = 21
          Color = 14745599
          DropDownBox.AutoDrop = True
          Enabled = False
          EditButton.Visible = False
          EditButtons = <
            item
              OnClick = DBComboBoxEhDropDownButtonClick
            end>
          Items.Strings = (
            '- Any -'
            'A'
            'B'
            'C')
          KeyItems.Strings = (
            'X'
            'A'
            'B'
            'C')
          ParentShowHint = False
          TabOrder = 2
          Tooltips = True
          Visible = True
          OnKeyDown = DBLookupComboboxEhKeyDown
          OnKeyPress = EhKeyPress
        end
        object TempRegimeFilterDBLookupComboboxEh: TDBLookupComboboxEh
          Left = 88
          Top = 73
          Width = 311
          Height = 21
          Anchors = [akLeft, akTop, akRight]
          Color = 14745599
          DataField = ''
          DropDownBox.Columns = <
            item
              Color = 16769232
              FieldName = 'NAME'
            end>
          DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
          DropDownBox.AutoDrop = True
          DropDownBox.Sizable = True
          Enabled = False
          EditButton.Visible = False
          EditButtons = <
            item
              OnClick = DBLookupComboboxEhDropDownButtonClick
            end>
          KeyField = 'ID'
          ListField = 'NAME'
          ListSource = TempRegimesFilterDataSource
          ParentShowHint = False
          TabOrder = 1
          Tooltips = True
          Visible = True
          OnKeyDown = DBLookupComboboxEhKeyDown
          OnKeyPress = EhKeyPress
        end
        object PharmGroupFilterDBLookupComboboxEh: TDBLookupComboboxEh
          Left = 88
          Top = 46
          Width = 311
          Height = 21
          Anchors = [akLeft, akTop, akRight]
          Color = 14745599
          DataField = ''
          DropDownBox.Columns = <
            item
              Color = 16769232
              FieldName = 'NAME'
            end>
          DropDownBox.Options = [dlgColLinesEh, dlgRowLinesEh]
          DropDownBox.AutoDrop = True
          DropDownBox.Sizable = True
          Enabled = False
          EditButton.Visible = False
          EditButtons = <
            item
              OnClick = DBLookupComboboxEhDropDownButtonClick
            end>
          KeyField = 'ID'
          ListField = 'NAME'
          ListSource = PharmGroupsFilterDataSource
          ParentShowHint = False
          TabOrder = 3
          Tooltips = True
          Visible = True
          OnKeyDown = DBLookupComboboxEhKeyDown
          OnKeyPress = EhKeyPress
        end
        object TracerOnlyDBCheckBoxEh: TDBCheckBoxEh
          Left = 315
          Top = 102
          Width = 84
          Height = 17
          Anchors = [akTop, akRight]
          Caption = 'Tracer only'
          TabOrder = 4
          OnKeyPress = EhKeyPress
          ValueChecked = '1'
          ValueUnchecked = '0'
        end
      end
      object ApplyFiltersButton: TButton
        Left = 226
        Top = 137
        Width = 89
        Height = 26
        Anchors = [akRight, akBottom]
        Caption = 'Apply Filters '
        ImageIndex = 7
        ImageMargins.Left = 3
        Images = ImageList
        TabOrder = 1
        OnClick = ApplyFiltersButtonClick
      end
      object ResetFiltersButton: TButton
        Left = 321
        Top = 138
        Width = 89
        Height = 26
        Anchors = [akRight, akBottom]
        Caption = 'Reset Filters'
        ImageIndex = 8
        ImageMargins.Left = 2
        Images = ImageList
        TabOrder = 2
        OnClick = ResetFiltersButtonClick
      end
    end
  end
  object ReadTransaction: TpFIBTransaction
    DefaultDatabase = MainForm.RemoteDatabase
    TimeoutAction = TARollback
    TRParams.Strings = (
      'read'
      'nowait'
      'rec_version'
      'read_committed')
    WatchUncommitedUpdates = True
    TPBMode = tpbDefault
    Left = 80
    Top = 184
  end
  object DataSet: TpFIBDataSet
    UpdateSQL.Strings = (
      '')
    DeleteSQL.Strings = (
      'delete from items'
      'where id = :OLD_ID'
      '    ')
    InsertSQL.Strings = (
      '')
    RefreshSQL.Strings = (
      'select'
      '    item_names.name||'
      
        '        iif(itemdrug_generic_names.name <> '#39#39' and itemdrug_gener' +
        'ic_names.name <> item_names.name, '#39' ['#39'||itemdrug_generic_names.n' +
        'ame||'#39']'#39', '#39#39')||'
      
        '        iif(items.description <> '#39#39', '#39', '#39'||items.description, '#39#39 +
        ') ||'
      
        '        iif(itemdrug_med_forms.name <> '#39#39', '#39', '#39'||itemdrug_med_fo' +
        'rms.name, '#39#39')||'
      
        '        iif(itemdrugs.dosage <> '#39#39', '#39', '#39'||itemdrugs.dosage, '#39#39') ' +
        'name,'
      '    items.id,'
      '    items.name_id,'
      '    items.category_id,'
      '    item_names.name item_name,'
      '    item_categories.name category_name,'
      '    item_basic_units.name basic_unit_name,'
      '    items.is_hazardous,'
      '    items.description,'
      '    itemdrug_generic_names.name generic_name,'
      '    itemdrug_med_forms.name med_form_name,'
      '    itemdrugs.dosage,'
      '    itemdrug_temp_regimes.name temp_regime_name,'
      '    itemdrugs.authorization_level,'
      '    itemdrugs.is_traced,'
      
        '    (select list(itemdrug_pharm_groups.name, '#39'; '#39'||ASCII_CHAR(13' +
        ')||ASCII_CHAR(10))'
      '     from itemdrug_pharm_groups_sets'
      
        '     join itemdrug_pharm_groups on itemdrug_pharm_groups.id = it' +
        'emdrug_pharm_groups_sets.pharm_group_id'
      
        '     where itemdrug_pharm_groups_sets.generic_name_id = itemdrug' +
        's.generic_name_id) pharm_groups_list'
      'from items'
      'join item_names on item_names.id = items.name_id'
      'join item_categories on item_categories.id = items.category_id'
      
        'join item_basic_units on item_basic_units.id = items.basic_unit_' +
        'id'
      'left join itemdrugs on itemdrugs.item_id = items.id'
      
        'left join itemdrug_med_forms on itemdrug_med_forms.id = itemdrug' +
        's.med_form_id'
      
        'left join itemdrug_generic_names on itemdrug_generic_names.id = ' +
        'itemdrugs.generic_name_id'
      
        'left join itemdrug_temp_regimes on itemdrug_temp_regimes.id = it' +
        'emdrugs.temp_regime_id'
      'where items.id = :OLD_ID'
      '')
    SelectSQL.Strings = (
      'select'
      '    item_names.name||'
      
        '        iif(itemdrug_generic_names.name <> '#39#39' and itemdrug_gener' +
        'ic_names.name <> item_names.name, '#39' ['#39'||itemdrug_generic_names.n' +
        'ame||'#39']'#39', '#39#39')||'
      
        '        iif(items.description <> '#39#39', '#39', '#39'||items.description, '#39#39 +
        ') ||'
      
        '        iif(itemdrug_med_forms.name <> '#39#39', '#39', '#39'||itemdrug_med_fo' +
        'rms.name, '#39#39')||'
      
        '        iif(itemdrugs.dosage <> '#39#39', '#39', '#39'||itemdrugs.dosage, '#39#39') ' +
        'name,'
      '    items.id,'
      '    items.name_id,'
      '    items.category_id,'
      '    item_names.name item_name,'
      '    item_categories.name category_name,'
      '    item_basic_units.name basic_unit_name,'
      '    items.is_hazardous,'
      '    items.description,'
      '    itemdrug_generic_names.name generic_name,'
      '    itemdrug_med_forms.name med_form_name,'
      '    itemdrugs.dosage,'
      '    itemdrug_temp_regimes.name temp_regime_name,'
      '    itemdrugs.authorization_level,'
      '    itemdrugs.is_traced,'
      
        '    (select list(itemdrug_pharm_groups.name, '#39'; '#39'||ASCII_CHAR(13' +
        ')||ASCII_CHAR(10))'
      '     from itemdrug_pharm_groups_sets'
      
        '     join itemdrug_pharm_groups on itemdrug_pharm_groups.id = it' +
        'emdrug_pharm_groups_sets.pharm_group_id'
      
        '     where itemdrug_pharm_groups_sets.generic_name_id = itemdrug' +
        's.generic_name_id) pharm_groups_list'
      'from items'
      'join item_names on item_names.id = items.name_id'
      'join item_categories on item_categories.id = items.category_id'
      
        'join item_basic_units on item_basic_units.id = items.basic_unit_' +
        'id'
      'left join itemdrugs on itemdrugs.item_id = items.id'
      
        'left join itemdrug_med_forms on itemdrug_med_forms.id = itemdrug' +
        's.med_form_id'
      
        'left join itemdrug_generic_names on itemdrug_generic_names.id = ' +
        'itemdrugs.generic_name_id'
      
        'left join itemdrug_temp_regimes on itemdrug_temp_regimes.id = it' +
        'emdrugs.temp_regime_id'
      'where'
      '    (cast(:FLT_NAME as varchar(1000)) = '#39#39' or'
      '    lower(item_names.name||'
      
        '        iif(itemdrug_generic_names.name <> '#39#39' and itemdrug_gener' +
        'ic_names.name <> item_names.name, '#39' ['#39'||itemdrug_generic_names.n' +
        'ame||'#39']'#39', '#39#39')||'
      
        '        iif(items.description <> '#39#39', '#39', '#39'||items.description, '#39#39 +
        ') ||'
      
        '        iif(itemdrug_med_forms.name <> '#39#39', '#39', '#39'||itemdrug_med_fo' +
        'rms.name, '#39#39')||'
      
        '        iif(itemdrugs.dosage <> '#39#39', '#39', '#39'||itemdrugs.dosage, '#39#39'))' +
        ' like '#39'%'#39'||lower(cast(:FLT_NAME as varchar(1000)))||'#39'%'#39') and'
      
        '    (:FLT_CATEGORY_ID = -1 or items.category_id = :FLT_CATEGORY_' +
        'ID) and'
      '    (:FLT_HAZARDOUS = 0 or items.is_hazardous = 1) and'
      
        '    (:FLT_GENERIC_NAME_ID = -1 or itemdrugs.generic_name_id = :F' +
        'LT_GENERIC_NAME_ID) and'
      
        '    (:FLT_TEMP_REGIME_ID = -1 or itemdrugs.temp_regime_id = :FLT' +
        '_TEMP_REGIME_ID) and'
      
        '    (:FLT_AUTH_LEVEL = '#39'X'#39' or itemdrugs.authorization_level = :F' +
        'LT_AUTH_LEVEL) and'
      '    (:FLT_TRACED = 0 or itemdrugs.is_traced = 1) and'
      '    (:FLT_PHARM_GROUP_ID = -1 or exists('
      '        select *'
      '        from itemdrug_pharm_groups_sets'
      '        where'
      
        '            itemdrug_pharm_groups_sets.generic_name_id = itemdru' +
        'gs.generic_name_id  and'
      
        '            itemdrug_pharm_groups_sets.pharm_group_id = :FLT_PHA' +
        'RM_GROUP_ID))'
      ''
      'order by name'
      '')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    UpdateTransaction = WriteTransaction
    Left = 168
    Top = 232
    oFetchAll = True
  end
  object DataSource: TDataSource
    DataSet = DataSet
    Left = 168
    Top = 280
  end
  object ImageList: TImageList
    ColorDepth = cd32Bit
    Left = 80
    Top = 232
    Bitmap = {
      494C010109001400300110001000FFFFFFFF2110FFFFFFFFFFFFFFFF424D3600
      0000000000003600000028000000400000003000000001002000000000000030
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000303030408080809050505061919191A2929
      292B2929292B1919191A03030304000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000050505064747464E7771689C4747484F5F67A3CE4758
      DEFF4758DEFF5F67A3CE42424248030303040000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000030303044646464DC49F68EFC59450FF4A5AC1E95B6EFCFF5A6D
      FAFF5A6DFAFF5B6EFCFF4F5BC2EB232323240000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000909090AC6A475EFEABE77FF8D7B94FF485FF5FF465DF5FF445B
      F4FF445BF4FF465DF5FF4B60F2FF6162697D0000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000A0A0A0BDAB482FFE8BC72FF857DADFF4B63F5FFFFFFFFFFFFFF
      FFFFFFFFFFFFFFFFFFFF4D64F4FF6465708A0000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000C0C0C0DD9B98DFFE7BA70FF948DB4FF6377F0FF2E49EBFF2E4A
      EBFF2E4AEBFF2E49EBFF677AEEFF60616A760000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000050505064747464EDEBE93FFEABF77FFD3B38AFF525FCBFF6579F0FF2F4A
      E8FF2F4AE8FF6679EFFF656FC2E60F0F0F100000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000505
      05064747464ECBA670EFF7D08FFFF0C988FFEDC481FFC39C6CFF6367ACE76574
      DDFF6775DBFF6F75A5BD26262627000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000050505064747
      464ECBA670EFF6D195FFF3CC8BFFECC482FFE6BC75FFE5BD7DFFC39E62EC4646
      464D050505060000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000050505064747464ECBA7
      73EFF7D29AFFF4CC8AFFEFC887FFE9C07BFFE2B771FFDCAE65FFDFB980FFBE99
      62EF4747464E0505050600000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000050505064747464ECBA874EFF7D5
      A0FFF3C780FFF2CA89FFECC37DFFE5BA74FFDFB26AFFD8AA61FFD1A054FFDBB8
      82FFB99460EF4747464E05050506000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000003F3F3F44CCAC7FEFFDF1DEFFF7DD
      B4FFF8DEB3FFF5D8A9FFEECB94FFE7C184FFDFB571FFD8A960FFD1A156FFC995
      47FFDBBA8BFFB99462EF3F3F3F44000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000006F6B668AF9DAACFFF3C680FFF3C9
      82FFF5CC89FFF0C884FFEBC07AFFE5B970FFDEB168FFD9A95EFFD3A357FFCD9C
      4EFFC79344FFD2AA6EFF756F688E000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000006F6B668AF9DCADFFEAC993FFE3C1
      8BFFE0BF89FFE4C490FFE7C794FFEACA98FFE6C592FFE1BF8AFFDAB67BFFD6B1
      75FFD3AC6FFFD8B482FF706B668A000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000006D6A6586D9BB8CFFC09246FFC08C
      38FFC48D35FFCD973FFFD6A04CFFDEAA57FFD8A34FFFCE9942FFC69037FFC18E
      3AFFC19247FFD2B07DFF756F688B000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000013131314726D67799C8D7AB3B9A0
      82DECAA985F7D0AE85FFD0AD84FFCFAC82FFCFAD82FFD0AD83FFC9A783F7B99F
      7FDE988A79AE716C667913131314000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000EFF0F000F4F4F400F1F3F200F1F3F200F2F2F300ECEDED000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000010707070804040405000000000000
      000000000000000000000000000000000000000000000000000000000000EEEF
      EF00E6F4ED00A1E1C30060CF9D0045C88F0045C88F0060CF9C00A1E1C200E4F2
      EB00E8E9E9000000000000000000000000000000000000000000000000005757
      576A46465ACE1C1C1C1D000000000000000000000000000000001C1C1C1D4646
      5ACE5757576A0000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000016161617706C668C4D4D4C56000000000000
      0000000000000000000000000000000000000000000000000000F0F1F000BDE8
      D20046C78D0025C0810024C1830024C1830024C1830024C0820025C0810046C6
      8C00BCE8D000E9EAEA00000000000000000000000000000000005F5F60800101
      A7FE0303F3FF343460DE21212122000000000000000021212122343460DE0303
      F3FF0101A7FE5F5F608000000000000000000000000000000000000000000000
      0000000000010000000037373739B4B3B3E88C8C8CAB15151516000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000013131314867C6EACD6A862FF706B668A000000000000
      00000000000000000000000000000000000000000000EEEFEE00B9E5CA0033C1
      830024C0820024C1830026C1840081CF980027BB720024C1830024C1830024C0
      820033C18000B8E4C900E4E6E50000000000000000005F5F61800202B9FF0B0B
      FEFF0C0CFEFF0808F5FF2D2D60E426262628262626282D2D61E40808F5FF0C0C
      FEFF0B0BFEFF0202B9FF5F5F6181000000000000000000000000000000000000
      000001010102000000003C3C3C3ED5D4D3FFC1BFBEFF3E3E3E41000000000101
      0102000000000000000000000000000000000000000000000000000000000000
      000000000000000000006764617AF3CE94FFDCB373FF706B668A000000000000
      00000000000000000000000000000000000000000000E1F1E6003DC07F0024C0
      820024C1830027C18400B3E8D100FEFEFE0067BF710024C1830024C1830024C1
      830024C082003DBF7C00DEEDE20000000000000000006161628E0000DCFF1111
      F9FF1313F9FF1313F9FF0E0EF3FF262662E9262662E90E0EF3FF1313F9FF1313
      F9FF1111F9FF0000DDFF6161638E000000000000000000000000000000000000
      000000000001000000003C3C3C3ED0CFCEFDBEBCBBFB3C3C3C3E000000000000
      0001000000000000000000000000000000000000000000000000000000000000
      000000000000000000006F6B668AF8DAA7FFE0BC84FF706B668A000000000000
      000000000000000000000000000000000000EFF0EF008FD5A60027C1820024C1
      830028C28400B7E9D3000000000000000000DBEBD0002CB7680024C1830024C1
      830024C1830027C080008ED4A400E4E6E500000000000C0C0C0D4F4F5EC40202
      CFFF1919F3FF1C1CF4FF1C1CF4FF1616F0FF1616F0FF1C1CF4FF1C1CF4FF1919
      F3FF0202CFFF4F4F5EC40C0C0C0D000000000000000000000000000000000000
      0000010101020000000136363638D3D2D1FEBEBCBBFE36363638000000010101
      0102000000000000000000000000000000000000000000000000000000000000
      00000000000000000000706C668CF8DEB1FFE5C594FF706C668C000000000000
      000000000000000000000000000000000000F4F4F40050C37F003AC88F0029C2
      8500BBEBD60000000000FEFEFE00FDFEFE00000000008CC9850033C3860024C1
      830024C183003AC88F0050C27B00EBECEC0000000000000000000C0C0C0D4F4F
      5CC30303C2FF2222EFFF2727EFFF2727EFFF2727EFFF2727EFFF2222EFFF0303
      C3FF4F4F5CC30C0C0C0D00000000000000000000000000000000000000000000
      0000020202030000000074747481D9D8D7FFC0BEBDFF71717181000000000202
      0203000000000000000000000000000000000000000000000000000000000000
      000000000000161616178A7C68BCF8DFB3FFE9CB9CFF8A7C69BC161616170000
      000000000000000000000000000000000000F0F3F1003ABC6F004ECE9B0095E1
      C20000000000FDFEFD00A5DFBD00C2EBD50000000000F2F8EE0066BA67004BC1
      800033C488004ECE9B003ABB6C00E9ECEA000000000000000000000000000B0B
      0B0C464652CE0909CAFF3333EBFF3333EBFF3333EBFF3333EBFF0909CBFF4646
      52CE0B0B0B0C0000000000000000000000000000000000000000000000000101
      0102000000004746464AB0AEADFEDBDAD9FCC1BFBEFC969493FE4646464A0000
      0000010101020000000000000000000000000000000000000000000000000000
      000016161617867B6DACF2C888FFF4CD8CFFEDC583FFE6BD7AFF867B6DAC1616
      161700000000000000000000000000000000F0F3F1003AB9680050CD990075CC
      9100F5FBF6008ED3A2005DC282006CC98F00F3FAF50000000000C5DFB60059B9
      680063C5820050CD98003BB76400E9EBE9000000000000000000000000004343
      434A16166DF63636E6FF4040E8FF4040E8FF4040E8FF4040E8FF3636E6FF1616
      6DF64343434A0000000000000000000000000000000000000000010101020000
      00001F1F1F2091908FEDB7B6B4FDDCDBD9FDC2C0BFFD9D9C9AFD858483ED1F1F
      1F20000000000101010200000000000000000000000000000000000000001616
      1617867B6DACF1CA8DFFF5CE8FFFF0C887FFE9C07BFFE4B974FFDFB87AFF857A
      6CAC16161617000000000000000000000000F2F2F3004DBA670057C177005EBF
      710074C8870068C47F0062C27C005EC17B009DD9AE0000000000000000008FC5
      7A005DBE6E0057C075004EB96300E9EAE90000000000000000004A4A4A531313
      71F94444E4FF4E4EE6FF4E4EE6FF4343E4FF4343E4FF4E4EE6FF4E4EE6FF4444
      E4FF131371F94A4A4A5300000000000000000000000000000000010101020909
      090A868585CD989795FFB8B7B6FBDEDDDAFFC4C2C1FF9D9B9AFB878584FF8282
      81CD0909090A010101020000000000000000000000000000000016161617867B
      6DACF3CD96FFF4CC8CFFF3CC8BFFECC482FFE6BB76FFDFB26BFFDBAF69FFDBB6
      7CFF857A6BAC161616170000000000000000ECEDEC0087C6780056AE46005BB7
      5E005CBC6A005FBF720062C1770064C2790064C27900D0ECD60000000000F5F9
      F20069B3520056AE430087C57500E0E2E000000000004F4F4F5C141476FB5252
      E2FF5C5CE4FF5C5CE4FF4F4FE1FF0808A7FF0808A7FF4F4FE1FF5C5CE4FF5C5C
      E4FF5252E2FF141476FB4F4F4F5C000000000000000000000000000000007B7B
      7AA0807C79FF999794FAB8B6B4FFDDDCD9FEC3C0BEFE9C9B98FF888582FA7472
      6FFF7B7A7AA10000000000000000000000000000000116161617867B6CACF3D2
      A0FFF3C885FFF4CB88FFEFC784FFE9BE78FFE2B66FFFDCAF66FFD5A65CFFD2A5
      5EFFD9B583FF84786AAC161616170000000100000000DCEAD700479E19005CAE
      41005CB352005BB65B005BB962005BBA64005BBA64006ABF6F00EEF7ED00FBFC
      F9008CC47200479E1800D8E5D20000000000070707080C0C4DF85353DEFF6C6C
      E3FF6C6CE3FF5C5CE0FF0909A4FF55555BBC55555BBC0909A9FF5C5CE0FF6C6C
      E3FF6C6CE3FF5353DEFF0C0C4DF80707070800000000000000005E5E5E687677
      7BFF88888CF999999CFEB7B6BAFEDADADCFEC2C0C4FE9D9DA0FE89898CFE8080
      83F9737478FF5E5E5E68000000000000000007070708867B6CABF6E1C3FFFAE5
      C7FFF7DEB4FFF7DCB0FFF1D19EFFEBC68CFFE3BB7AFFDBAF68FFD5A55BFFCD9C
      4FFFCD9E58FFD9BA8DFF84796AAB0707070800000000E7E8E600ABD09700499B
      18005DAA33005DAD3B005CAF42005CB046005CB045005CAE410081BE650088BF
      6800499A1800AACF9600DCDFDB0000000000000000005D5D5D780F0F8EFE6E6E
      E0FF6969DFFF0A0AA7FF55555CBB080808090808080955555EBB0A0AB1FF6969
      DFFF6E6EE0FF0F0F8DFE5D5D5D780000000000000000000000008D806AB3AB87
      42FFB99A59FCC5AB6CFFD3BE85FFE2D29CFFD9C68EFFC9B274FFBEA362FFB595
      53FCAA8640FF8D826AB300000000000000000A0A0A0BD8B27DFFF5CC8DFFF3C6
      7DFFF4CA86FFF3CC88FFEDC480FFE8BD75FFE1B56CFFDCAD63FFD6A65AFFD09F
      53FFCA984AFFC48D3DFFCDA671FF0A0A0A0B0000000000000000E8E9E800AACF
      97004796170057A12A005DA632005DA732005DA732005DA6320057A02A004795
      1700AACE9600DFE1DF0000000000000000000000000000000000606061861212
      9AFF0B0BB4FF56565FB908080809000000000000000008080809565660BA0B0B
      BEFF121297FF60606186000000000000000000000000000000008E8067A5C59A
      47F6CFAC61F2DABC73F6E1CB88F6EADA99F6E6D290F6DDC47CF6D7B66AF6CDA8
      5CF2C59843F68F8167A500000000000000000A0A0A0BDAB381FFF0CC92FFE5C3
      8CFFE2C18CFFE2C28FFFE6C592FFE9C997FFE9C896FFE4C28EFFDEBC87FFD9B4
      79FFD4AD70FFCFA565FFCDA46EFF0A0A0A0B000000000000000000000000E4E5
      E300DBE7D50089B96B00549B28004490110044901100549A280089B96B00D8E4
      D200DCDEDB000000000000000000000000000000000000000000000000006161
      638D5B5B63B20707070800000000000000000000000000000000070707085B5B
      64B26161638D0000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000005050506D3AE7BFFC19651FFBF8D
      3CFFC38E38FFC89139FFD19C45FFDAA652FFDDA855FFD39D49FFCA943CFFC490
      3AFFC08F3EFFC29750FFCCA470FF050505060000000000000000000000000000
      000000000000E4E5E400EBECEB00E9EBE900E9EBE900E9EAE900E0E2E0000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000004B4A494E857D7392AC98
      7FCBC2A581ECD1AE86FFD0AE84FFCFAC83FFCFAC82FFCFAD82FFD0AD83FFC0A3
      80ECAC987ECC8179708D4B4A484E000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00006C635E706C635E7000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000002D2D2D2E4C4C4C4F5A5A
      5A5F6767676F6A6A6A74747474807373737F7373737F747474806A6A6A746868
      68705C5C5C624F4F4F532E2E2E2F000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000001F1F
      1F20CE7441EFA2816CAF00000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000202020216F6F6F807171
      7184515151555959595F6464646B6C6C6C746C6C6C746464646B5D5D5D625C5C
      5C61505050534040404223232324000000000000000000000000000000000000
      000000000000000000010F0F0F1015151516151515160F0F0F10000000010000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000000000000AC7E
      63BFD7692AFFDA6F2EFFDE7633FFE17D38FFE5863DFFA78972AF3F3E3D400000
      00000000000000000000000000000000000000000000000000004545454B0A08
      07FF626464B21A1A1A1B00000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000F0F0F1039916CED37AC86FF37AC86FF39916CED0F0F0F100000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000000000006B625D70D361
      24FFD66728FFD96D2DFFDC7331FFDF7936FFE3813AFFE6883FFFE88D43FF5E5A
      55600000000000000000000000000000000000000000000000002929292B3E4E
      55FFB3DDF1FFC5E9F9FF9FA8AAAA131313140000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000001515151629A77CFF46D0AFFF46D0AFFF29A77CFF151515160000
      0000000000000000000000000000000000000000000000000000000000010303
      0304050505060606060706060607060606070606060706060607060606070505
      0506020202030000000100000000000000000000000000000000C66636EFD25F
      22FFD56426FFD76A2AFFC58053DF7B6F66807C6F678089786C8FCD8E5EDFE78B
      41FF4F4C4A5000000000000000000000000000000000000000000A0A0A0BB0E9
      FFFFAEDBF2FFBFE2F3FFBCE3F4FF58BFEAF30000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000010F0F
      0F10151515162929292A2BAC84FF4AD3B4FF4AD3B4FF2BAC84FF2929292A1515
      15160F0F0F1000000001000000000000000000000000000000010A0A0A0B1919
      191A252525262A2A2A2B2A2A2A2B2A2A2A2B2A2A2A2B2A2A2A2B282828292020
      20211010101104040405000000000000000000000000000000002F2E2E309377
      689FD36124FFD66628FFB9805CCF000000000000000000000000000000006D65
      5F70C08D68CF000000000000000000000000000000000000000000000000A0D8
      F9FFB0D9F0FF83CEF0FF4DBDF1FF4CBEEFFF6C98A9AC00000000000000000000
      00000000000000000000000000000000000000000000000000000F0F0F103A9D
      7BED3AB895FF3AB895FF47C9AAFF4ED6BAFF4ED6BAFF47C9AAFF3AB895FF3AB8
      95FF3A9D7BED0F0F0F10000000000000000000000000030303041919191A0531
      AFFF0531AFFF0531AFFF0531AFFF0531AFFF0531AFFF0531AFFF0531AFFF0531
      AFFF636E8EA80C0C0C0D00000000000000000000000000000000000000000000
      00001F1F1F2094796A9FCC713FEF0F0F0F100000000000000000000000000000
      00002F2F2E301F1F1F20000000000000000000000000000000000000000097C5
      E1E32FB4E9FF6AC7F4FF35B7EBFF58C0F1FF38B8ECFF4A4F5252000000000000
      0000000000000000000000000000000000000000000000000000151515162EB8
      92FF53DAC0FF53DAC0FF53DAC0FF53DAC0FF53DAC0FF53DAC0FF53DAC0FF53DA
      C0FF2EB892FF151515160000000000000000000000000505050623232324174B
      D9FF1447D7FF1447D7FF1447D7FF1447D7FF1447D7FF1447D7FF1447D7FF1447
      D7FF0634BAFF1111111200000000000000000000000000000000000000000000
      000000000000000000000F0F0F100F0F0F100000000000000000000000000000
      000000000000000000000000000000000000000000000000000000000000595F
      626236B6ECFF2EB4EAFF53BFEFFF29B3E9FF4EBEEFFF25B3EBFE0B0B0B0C0000
      00000000000000000000000000000000000000000000000000001515151632BF
      9CFF5CE1CDFF5CE1CDFF5CE1CDFF5CE1CDFF5CE1CDFF5CE1CDFF5CE1CDFF5CE1
      CDFF32BF9CFF1515151600000000000000000000000005050506202020214671
      E2FF436DE0FF436DE0FF436DE0FF436DE0FF436DE0FF436DE0FF436DE0FF436D
      E0FF0839C7FF0F0F0F1000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000082A9BCBC29B4E9FF44BAEDFF2AB3E8FF31B6EBFF38B8EBFF57A3BEC50000
      00000000000000000000000000000000000000000000000000000F0F0F103EAD
      8EED4DCAABFF4DCAABFF5CD8BFFF5FE4D0FF5FE4D0FF5CD8BFFF4DCAABFF4DCA
      ABFF3EAD8EED0F0F0F1000000000000000000000000002020203101010117596
      E9FF9FB5EFFF9FB5EFFF9FB5EFFF9FB5EFFF9FB5EFFF9FB5EFFF9FB5EFFF9FB5
      EFFF093CD2FF07070708000000000000000000000000000000001F1F1F200000
      000000000000000000000000000000000000C1744BDF7A6C64800F0F0F100000
      0000000000000000000000000000000000000000000000000000000000000000
      00000606060767C5F2F925B1E9FF3FB9ECFF0BABE3FF3EB9EDFF22B1E8FF5967
      6C6D000000000000000000000000000000000000000000000000000000010F0F
      0F10151515162929292A33C9A7FF61E6D4FF61E6D4FF33C9A7FF2929292A1515
      15160F0F0F100000000100000000000000000000000000000001040404050C0C
      0C0D121212131515151615151516151515161515151615151516131313140F0F
      0F100707070802020203000000000000000000000000000000009D7463AF6B60
      5C70000000000000000000000000000000009F7A67AFD15D21FFD25F22FF9378
      699F1F1F1F200000000000000000000000000000000000000000000000000000
      0000000000004446474753C0F0FF29B3E8FF21B1E8FF10ACE4FF2FB6EBFF04AA
      E6FF262626270000000000000000000000000000000000000000000000000000
      0000000000001515151634CDACFF64E8D6FF64E8D6FF34CDACFF151515160000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000000000003F3D3C40C74A
      13FFBA6743DF856F658F4E4A48506B615C70B37555CFCE581DFFCF591EFFD05B
      20FFD05C20FF1F1F1F2000000000000000000000000000000000000000000000
      000000000000000000008298A2A246BBEEFF25B1E8FF00A5E4FF43BBE5FFEBE7
      DAFF817CADE00000000000000000000000000000000000000000000000000000
      0000000000000F0F0F103EB89AED4ED4B6FF4ED4B6FF3EB89AED0F0F0F100000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000005C56
      5360C74913FFC84B14FFC94D16FFCA5017FFCB5119FFCC531AFFCD541BFFCD55
      1CFF9E7865AF0000000000000000000000000000000000000000000000000000
      000000000000000000000000000081C6EAEB31B7F0FF9ADAE8FFE9D9DCFF201E
      99FF020293FF6060717B00000000000000000000000000000000000000000000
      000000000000000000010F0F0F1015151516151515160F0F0F10000000010000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00003F3D3C40A7725BBFC84A13FFC84C14FFC94D16FFCA4F17FFCA5017FFC45F
      31EF0F0F0F100000000000000000000000000000000000000000000000000000
      000000000000000000000000000036373738DADED2FF857AB3FF00008CFF0909
      99FF1818ADFF4444484A00000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000003F3D3C403F3D3C409174659FC84C14FF4E4A
      4850000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000071708694000090FF0F0F9EFF5454
      ADD3141414150000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000004E4A48509C7462AF0000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000067679AB1616172790000
      000000000000000000000000000000000000424D3E000000000000003E000000
      2800000040000000300000000100010000000000800100000000000000000000
      000000000000000000000000FFFFFF00FE01000000000000FC00000000000000
      F800000000000000F800000000000000F800000000000000F800000000000000
      F000000000000000E001000000000000C0070000000000008003000000000000
      0001000000000000000100000000000000010000000000000001000000000000
      00010000000000000001000000000000F81FFFFFFFFFFE3FE007E3C7FFFFFE3F
      C003C183F43FFC3F80018001F42FFC3F80018001F42FFC3F03008001F00FFC3F
      0480C003F42FF81F0880E007E817F00F0040E007D00BE0070060C003C003C003
      00208001E007000080010000C003000080018001C0030000C003C183C0030000
      E007E3C7FFFF0000F81FFFFFFFFF8001FFFFFFFFF3FF8001FFFFFFFFE3FF8001
      F81FFFFFE01FC3FFF81FFFFFC00FC0FFF81FC003C007C0FFC0038003C1E7E07F
      C0038003F0F3E03FC0038003FCFFE01FC0038003FFFFF01FC0038003DF1FF00F
      C0038003CF07F807F81FFFFFC003FC07F81FFFFFE007FE03F81FFFFFF007FE03
      FFFFFFFFFE0FFF07FFFFFFFFFF9FFF9F00000000000000000000000000000000
      000000000000}
  end
  object CategoriesDataSet: TpFIBDataSet
    UpdateSQL.Strings = (
      'update item_categories'
      'set name = :NAME'
      'where id = :OLD_ID'
      '')
    DeleteSQL.Strings = (
      'delete from item_categories'
      'where id = :OLD_ID'
      '    ')
    InsertSQL.Strings = (
      'insert into item_categories(name)'
      'values(:NAME)'
      'returning(id)')
    RefreshSQL.Strings = (
      'select id, name'
      'from item_categories'
      'where item_categories.id = :OLD_ID'
      '    ')
    SelectSQL.Strings = (
      'select id, name'
      'from item_categories'
      'order by name')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    UpdateTransaction = WriteTransaction
    Left = 416
    Top = 248
    oFetchAll = True
  end
  object CategoriesDataSource: TDataSource
    DataSet = CategoriesDataSet
    Left = 400
    Top = 264
  end
  object PropStorageEh: TPropStorageEh
    StorageManager = MainForm.RegPropStorageManEh
    StoredProps.Strings = (
      '<P>.Height'
      '<P>.Left'
      '<P>.PixelsPerInch'
      '<P>.Top'
      '<P>.Width'
      '<P>.WindowState')
    Left = 80
    Top = 288
  end
  object BasicUnitsDataSet: TpFIBDataSet
    UpdateSQL.Strings = (
      'update item_basic_units'
      'set name = :NAME'
      'where ID = :OLD_ID'
      '    ')
    DeleteSQL.Strings = (
      'delete from item_basic_units'
      'where id = :OLD_ID'
      '    ')
    InsertSQL.Strings = (
      'insert into item_basic_units(name)'
      'values(:NAME)'
      'returning(id)')
    RefreshSQL.Strings = (
      'select id, name'
      'from item_basic_units'
      'where item_basic_units.id = :OLD_ID'
      '    ')
    SelectSQL.Strings = (
      'select id, name'
      'from item_basic_units'
      'order by name')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    UpdateTransaction = WriteTransaction
    Left = 416
    Top = 312
    oFetchAll = True
  end
  object BasicUnitsDataSource: TDataSource
    DataSet = BasicUnitsDataSet
    Left = 400
    Top = 328
  end
  object ItemNamesDataSet: TpFIBDataSet
    UpdateSQL.Strings = (
      'update item_names'
      'set name = :NAME'
      'where id = :OLD_ID'
      '    ')
    DeleteSQL.Strings = (
      'delete from item_names'
      'where id = :OLD_ID'
      '    ')
    InsertSQL.Strings = (
      'insert into item_names(name)'
      'values(:NAME)'
      'returning(id)')
    RefreshSQL.Strings = (
      'select id, name'
      'from item_names'
      'where id = :OLD_ID')
    SelectSQL.Strings = (
      'select id, name'
      'from item_names'
      'order by name')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    UpdateTransaction = WriteTransaction
    Left = 416
    Top = 184
    oFetchAll = True
  end
  object ItemNamesDataSource: TDataSource
    DataSet = ItemNamesDataSet
    Left = 400
    Top = 200
  end
  object GenericNamesDataSource: TDataSource
    DataSet = GenericNamesDataSet
    Left = 528
    Top = 200
  end
  object GenericNamesDataSet: TpFIBDataSet
    UpdateSQL.Strings = (
      'update itemdrug_generic_names'
      'set name = :NAME'
      'where id = :OLD_ID'
      '    ')
    DeleteSQL.Strings = (
      'delete from itemdrug_generic_names'
      'where id = :OLD_ID'
      '    ')
    InsertSQL.Strings = (
      'insert into itemdrug_generic_names(name)'
      'values(:NAME)'
      'returning(id)')
    RefreshSQL.Strings = (
      'select id, name'
      'from itemdrug_generic_names'
      'where itemdrug_generic_names.id = :OLD_ID'
      '')
    SelectSQL.Strings = (
      'select id, name'
      'from itemdrug_generic_names'
      'order by name')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    UpdateTransaction = WriteTransaction
    Left = 544
    Top = 184
    oFetchAll = True
  end
  object MedFormsDataSource: TDataSource
    DataSet = MedFormsDataSet
    Left = 528
    Top = 264
  end
  object MedFormsDataSet: TpFIBDataSet
    UpdateSQL.Strings = (
      'update itemdrug_med_forms'
      'set name = :NAME'
      'where id = :OLD_ID'
      '    ')
    DeleteSQL.Strings = (
      'delete from itemdrug_med_forms'
      'where id = :OLD_ID'
      '    ')
    InsertSQL.Strings = (
      'insert into itemdrug_med_forms(name)'
      'values(:NAME)'
      'returning(id)')
    RefreshSQL.Strings = (
      'select id, name'
      'from itemdrug_med_forms'
      'where itemdrug_med_forms.id = :OLD_ID'
      '    ')
    SelectSQL.Strings = (
      'select id, name'
      'from itemdrug_med_forms'
      'order by name')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    UpdateTransaction = WriteTransaction
    Left = 544
    Top = 248
    oFetchAll = True
  end
  object PharmGroupsSetDataSet: TpFIBDataSet
    CachedUpdates = True
    UpdateSQL.Strings = (
      'update'
      '    itemdrug_pharm_groups_sets'
      'set'
      '    generic_name_id = :GENERIC_NAME_ID,'
      '    pharm_group_id = :PHARM_GROUP_ID'
      '')
    DeleteSQL.Strings = (
      '')
    InsertSQL.Strings = (
      '')
    RefreshSQL.Strings = (
      'select'
      
        '    iif(itemdrug_pharm_groups_sets.pharm_group_id is null, 0, 1)' +
        ' is_selected,'
      '    itemdrug_pharm_groups.name,'
      '    itemdrug_pharm_groups.id'
      'from'
      '    itemdrug_pharm_groups'
      'left join itemdrug_pharm_groups_sets on'
      
        '    itemdrug_pharm_groups_sets.pharm_group_id = itemdrug_pharm_g' +
        'roups.id and'
      
        '    itemdrug_pharm_groups_sets.generic_name_id = :GENERIC_NAME_I' +
        'D'
      'where'
      
        '    itemdrug_pharm_groups_sets.generic_name_id = :OLD_GENERIC_NA' +
        'ME_ID and'
      '    itemdrug_pharm_groups.id = :OLD_ID'
      ''
      ' ')
    SelectSQL.Strings = (
      'select'
      
        '    iif(itemdrug_pharm_groups_sets.pharm_group_id is null, 0, 1)' +
        ' is_selected,'
      '    itemdrug_pharm_groups.name,'
      '    itemdrug_pharm_groups.id'
      'from'
      '    itemdrug_pharm_groups'
      'left join itemdrug_pharm_groups_sets on'
      
        '    itemdrug_pharm_groups_sets.pharm_group_id = itemdrug_pharm_g' +
        'roups.id and'
      
        '    itemdrug_pharm_groups_sets.generic_name_id = :GENERIC_NAME_I' +
        'D'
      'order by'
      '    is_selected desc,'
      '    name'
      '')
    Filter = 'is_selected=1'
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    UpdateTransaction = WriteTransaction
    Filtered = True
    Left = 680
    Top = 312
    oFetchAll = True
  end
  object PharmGroupsSetDataSource: TDataSource
    DataSet = PharmGroupsSetDataSet
    Left = 664
    Top = 328
  end
  object WriteTransaction: TpFIBTransaction
    DefaultDatabase = MainForm.RemoteDatabase
    TimeoutAction = TARollback
    TRParams.Strings = (
      'write'
      'nowait'
      'rec_version'
      'read_committed')
    WatchUncommitedUpdates = True
    TPBMode = tpbDefault
    Left = 168
    Top = 184
  end
  object AddPharmGroupQuery: TpFIBQuery
    Transaction = WriteTransaction
    Database = MainForm.RemoteDatabase
    SQL.Strings = (
      'insert into itemdrug_pharm_groups_sets ('
      '    generic_name_id,'
      '    pharm_group_id'
      ') values ('
      '    :GENERIC_NAME_ID,'
      '    :PHARM_GROUP_ID'
      ')')
    Left = 544
    Top = 312
    qoStartTransaction = True
  end
  object ClearPharmGroupSetQuery: TpFIBQuery
    Transaction = WriteTransaction
    Database = MainForm.RemoteDatabase
    SQL.Strings = (
      'delete from itemdrug_pharm_groups_sets'
      'where generic_name_id=:GENERIC_NAME_ID')
    Left = 536
    Top = 328
    qoStartTransaction = True
  end
  object UpdateInsertItemQuery: TpFIBQuery
    Transaction = WriteTransaction
    Database = MainForm.RemoteDatabase
    SQL.Strings = (
      'update or insert into items ('
      '    id,'
      '    name_id,'
      '    category_id,'
      '    description,'
      '    basic_unit_id,'
      '    is_hazardous'
      ') values ('
      '    :ID,'
      '    :NAME_ID,'
      '    :CATEGORY_ID,'
      '    :DESCRIPTION,'
      '    :BASIC_UNIT_ID,'
      '    :IS_HAZARDOUS'
      ')'
      'matching(id)'
      'returning(id)')
    Left = 288
    Top = 184
    qoStartTransaction = True
  end
  object UpdateInsertItemDrugQuery: TpFIBQuery
    Transaction = WriteTransaction
    Database = MainForm.RemoteDatabase
    SQL.Strings = (
      'update or insert into itemdrugs ('
      '    item_id,'
      '    generic_name_id,'
      '    med_form_id,'
      '    dosage,'
      '    temp_regime_id,'
      '    authorization_level,'
      '    is_traced'
      ') values ('
      '    :ITEM_ID,'
      '    :GENERIC_NAME_ID,'
      '    :MED_FORM_ID,'
      '    :DOSAGE,'
      '    :TEMP_REGIME_ID,'
      '    :AUTHORIZATION_LEVEL,'
      '    :IS_TRACED'
      ')'
      'matching(item_id)')
    Left = 288
    Top = 248
    qoStartTransaction = True
  end
  object DeleteItemQuery: TpFIBQuery
    Transaction = WriteTransaction
    Database = MainForm.RemoteDatabase
    SQL.Strings = (
      'delete from items'
      'where id = :ID')
    Left = 272
    Top = 200
    qoStartTransaction = True
  end
  object DeleteItemDrugQuery: TpFIBQuery
    Transaction = WriteTransaction
    Database = MainForm.RemoteDatabase
    SQL.Strings = (
      'delete from itemdrugs'
      'where item_id = :ITEM_ID')
    Left = 272
    Top = 264
    qoStartTransaction = True
  end
  object TempRegimesDataSet: TpFIBDataSet
    UpdateSQL.Strings = (
      'update itemdrug_temp_regimes'
      'set name = :NAME'
      'where id = :OLD_ID'
      '    ')
    DeleteSQL.Strings = (
      'delete from itemdrug_temp_regimes'
      'where id = :OLD_ID'
      '    ')
    InsertSQL.Strings = (
      'insert into itemdrug_temp_regimes(name)'
      'values(:NAME)'
      'returning(id)')
    RefreshSQL.Strings = (
      'select id, name'
      'from itemdrug_temp_regimes'
      'where id = :OLD_ID'
      '')
    SelectSQL.Strings = (
      'select id, name'
      'from itemdrug_temp_regimes'
      'order by id')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    UpdateTransaction = WriteTransaction
    Left = 656
    Top = 184
    oFetchAll = True
  end
  object TempRegimesDataSource: TDataSource
    DataSet = TempRegimesDataSet
    Left = 640
    Top = 200
  end
  object ItemNameFilterDataSet: TpFIBDataSet
    SelectSQL.Strings = (
      'select id, name'
      'from item_names'
      'order by name')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    Left = 304
    Top = 40
    oFetchAll = True
  end
  object ItemNameFilterDataSource: TDataSource
    DataSet = ItemNameFilterDataSet
    Left = 288
    Top = 56
  end
  object CategoriesFilterDataSet: TpFIBDataSet
    SelectSQL.Strings = (
      'select -1 id, '#39'- Any -'#39' name'
      'from dual'
      'union all'
      'select id, name'
      'from ('
      '    select id, name'
      '    from item_categories'
      '    order by name'
      ')')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    Left = 304
    Top = 104
    oFetchAll = True
  end
  object CategoriesFilterDataSource: TDataSource
    DataSet = CategoriesFilterDataSet
    Left = 288
    Top = 120
  end
  object GenericNamesFilterDataSet: TpFIBDataSet
    SelectSQL.Strings = (
      'select -1 id, '#39'- Any -'#39' name'
      'from dual'
      'union all'
      'select id, name'
      'from ('
      '    select id, name'
      '    from itemdrug_generic_names'
      '    order by name'
      ')')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    Left = 504
    Top = 24
    oFetchAll = True
  end
  object GenericNamesFilterDataSource: TDataSource
    DataSet = GenericNamesFilterDataSet
    Left = 488
    Top = 40
  end
  object TempRegimesFilterDataSet: TpFIBDataSet
    SelectSQL.Strings = (
      'select -1 id, '#39'- Any -'#39' name'
      'from dual'
      'union all'
      'select id, name'
      'from ('
      '    select id, name'
      '    from itemdrug_temp_regimes'
      '    order by id'
      ')')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    Left = 624
    Top = 24
    oFetchAll = True
  end
  object TempRegimesFilterDataSource: TDataSource
    DataSet = TempRegimesFilterDataSet
    Left = 608
    Top = 40
  end
  object PharmGroupsFilterDataSource: TDataSource
    DataSet = PharmGroupsFilterDataSet
    Left = 752
    Top = 40
  end
  object PharmGroupsFilterDataSet: TpFIBDataSet
    SelectSQL.Strings = (
      'select -1 id, '#39'- Any -'#39' name'
      'from dual'
      'union all'
      'select id, name'
      'from ('
      '    select id, name'
      '    from itemdrug_pharm_groups'
      '    order by name'
      ')'
      '')
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    Left = 768
    Top = 24
    oFetchAll = True
  end
  object MRUCategoriesQuery: TpFIBQuery
    Transaction = ReadTransaction
    Database = MainForm.RemoteDatabase
    SQL.Strings = (
      'select name_id, category_id, count(*) cnt'
      'from items'
      'group by name_id, category_id'
      '')
    Left = 288
    Top = 320
    qoStartTransaction = True
  end
end
